package com.hafu.dao;

import com.hafu.model.RuKuDetail;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class RuKuDetailDao
{
    //添加入库明细
    public boolean addRuKuDetail(RuKuDetail rukudetail, Connection Conn) throws SQLException
    {
        String sql="insert into ruku_detail(ruku_id, sp_name, price, num) values(?,?,?,?)";
        PreparedStatement pstmt = Conn.prepareStatement(sql);
        pstmt.setInt(1, rukudetail.getRukuID());
        pstmt.setString(2, rukudetail.getSpname());
        pstmt.setBigDecimal( 3, rukudetail.getPrice());
        pstmt.setInt( 4, rukudetail.getNum());
        int i = pstmt.executeUpdate();
        if (i>0){
            return true;
        }else{
            return false;
        }
    }

}
